advanced entity relationship modeling